<?php
require_once "../Common/database.php";
require_once "../Common/values.php";


$query="INSERT INTO tbljobs SELECT * FROM tbljobsarchive WHERE LogNumber='$_POST[LogNumber]'";
mysql_query($query);
$query="DELETE FROM tbljobsarchive WHERE LogNumber='$_POST[LogNumber]'";
mysql_query($query);
$query="INSERT INTO tblsolutions SELECT * FROM tblsolutionsarchive WHERE LogNumber='$_POST[LogNumber]'";
mysql_query($query);
$query="DELETE FROM tblsolutionsarchive WHERE LogNumber='$_POST[LogNumber]'";
mysql_query($query);
echo 'Retrieve Log number : '.$_POST[LogNumber].'<br>';




 

echo '<br><a href="../index.php?p=shview">Back</a>';

?>
